Spread ASP.NET 6.0 Product Documentation
AddRange(NamedStyle[]) Method
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > NamedStyleCollection Class > AddRange Method : AddRange(NamedStyle[]) Method


array
Array of NamedStyle objects to add to the collection

Glossary Item Box

Adds an array of NamedStyle objects to the collection.

Syntax

Visual Basic (Declaration) 
Public Overloads Overridable Sub AddRange( _
   ByVal array() As NamedStyle _
) 
Visual Basic (Usage)Copy Code
Dim instance As NamedStyleCollection
Dim array() As NamedStyle
 
instance.AddRange(array)
C# 
public virtual void AddRange( 
   NamedStyle[] array
)

Parameters

array
Array of NamedStyle objects to add to the collection

Remarks

This method adds an array of NamedStyle objects to the collection.

Example

This example adds a range of styles to the collection.
C#Copy Code
FarPoint.Web.Spread.NamedStyleCollection nsc = new FarPoint.Web.Spread.NamedStyleCollection();
FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault");
FarPoint.Web.Spread.NamedStyle ns1 = new FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault");
System.Collections.ArrayList c = new System.Collections.ArrayList(2);
ns.BackColor = Color.Yellow;
ns.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue);
ns1.BackColor = Color.Teal;
ns1.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red);
c.Add(ns);
c.Add(ns1);
nsc.AddRange(c);
FpSpread1.NamedStyles.AddRange(new Object[] {nsc[0], nsc[1]});
FpSpread1.ActiveSheetView.DefaultStyle = nsc[0];
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc[1];
Visual BasicCopy Code
Dim nsc As New FarPoint.Web.Spread.NamedStyleCollection
Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault")
Dim ns1 As New FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault")
Dim c As New System.Collections.ArrayList(2)
ns.BackColor = Color.Yellow
ns.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue)
ns1.BackColor = Color.Teal
ns1.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red)
c.Add(ns)
c.Add(ns1)
nsc.AddRange(c)
FpSpread1.NamedStyles.AddRange(New Object() {nsc(0), nsc(1)})
FpSpread1.ActiveSheetView.DefaultStyle = nsc(0)
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc(1)

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.